package org.example.system.mapper;

import org.example.system.entity.RouteSpot;
import org.example.system.entity.ScenicSpot;
import org.apache.ibatis.annotations.Param;
import java.util.List;

public interface RouteSpotMapper {
    int insert(RouteSpot routeSpot);
    int deleteById(Long id);
    int update(RouteSpot routeSpot);
    RouteSpot selectById(Long id);
    List<RouteSpot> selectAll();
    List<RouteSpot> selectByRouteId(Long routeId);
    List<ScenicSpot> selectScenicSpotsByRouteId(@Param("routeId") Long routeId);
    int addScenicSpotToRoute(@Param("routeId") Long routeId, @Param("scenicSpotId") Long scenicSpotId);
    int removeScenicSpotFromRoute(@Param("routeId") Long routeId, @Param("scenicSpotId") Long scenicSpotId);
} 